trouble with db-restore
От | Heiko Irrgang |
---|---|
Тема | trouble with db-restore |
Дата | |
Msg-id | a04320402b680bd36b8ef@[192.168.66.11] обсуждение исходный текст |
Ответы |
Re: trouble with db-restore
Re: trouble with db-restore |
Список | pgsql-general |
Hi, Yesterday our system-harddisk crashed and i had to restore the postgres databases from the backup-tape. i simply use pg_dumpall with no params for dumping the data, but when i used psql for restoring the data, every view was created as a table and was filled up with the data which the view had been delivered at the time of the backup. it was no problem, because actually we dont use much views so i could restored it by hand. but the question is, is it possible to backup views, and the bigger question for me is, what additional surprises do i have to expect from pg_dumpall? -- SC-Networks www: www.SC-Networks.de Web Design, Netzwerke, 3D Animation und Multimedia Heiko Irrgang Tel.: 08856/9392-00 Im Thal 2 Fax: 08856/9392-01 82377 Penzberg Mail: Irrgang@SC-Networks.de
В списке pgsql-general по дате отправления: